Trip Report and Expenses

Introduction

The Trip Report and Expenses feature in the VSD Fleet Management System (VSD Fleet MS) provides detailed reporting on vehicle trips, transporter types, driver details, routes, and trip expenses. The report is useful for monitoring both USD and TZS trip expenses and tracking trip statuses for fleet management.

1. Accessing the Report

To access the Trip Report and Expenses:

• Navigate to Reports:

• Log in to the Frappe system.

• Navigate to the Reports section.

• Search for "Trip Report and Expenses".

Filter Options:

From Date: Select the starting date of the period you want to analyze.

To Date: Select the end date of the period.

These filters help you narrow down the trips between specific dates.

Status (optional): Filter trips by their status (e.g., "In Progress", "Completed").

2. Filters and Data Input

The report allows you to customize the data displayed by applying filters:

3. Report Columns

The Trip Report and Expenses displays several columns that give insights into each trip's details:

Reference: The unique trip identifier, linking to the detailed trip document in the system.

Transporter Type: The type of transporter (e.g., "In House", "Subcontractor").

Transporter Name: Name of the transporter (for subcontracted trips).

Vehicle: The license plate number of the vehicle assigned to the trip.

Driver: Name of the driver responsible for the trip.

Route: The route taken by the vehicle for the trip.

Status: Current status of the trip (e.g., "En Route", "Completed").

Trip Expenses (USD): Total approved trip expenses in USD currency.

Trip Expenses (TZS): Total approved trip expenses in TZS currency.

Posting Date: Date when the trip was recorded in the system.

Generating the Report

To generate the report:

• Select the desired From Date and To Date.

• Optionally, apply filters such as Status to further narrow down the data.

• Click Generate Report to fetch the results.

The report will display the relevant data in a tabular format based on your filter inputs.

6. Usage and Insights

The report is useful for:

• Expense Tracking: Monitoring and auditing trip-related expenses, broken down into USD and TZS.

• Transporter Management: Reviewing whether trips were handled in-house or by subcontractors.

• Driver and Vehicle Performance: Tracking which drivers and vehicles were involved in trips during a specific time frame.

• Trip Progress Monitoring: Keeping tabs on trip statuses to ensure all trips are properly documented and completed.